package com.tedu._04mybatis.mapper;

import com.tedu._04mybatis.pojo.Comment;
import com.tedu._04mybatis.pojo.CommentVO1;
import com.tedu._04mybatis.pojo.CommentVO2;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface CommentMapper {

    //@Insert("INSERT INTO comment(content,created,weibo_id,user_id) " +
      //      "VALUES(#{content},#{created},#{weiboId},#{userId})")
    int insertComment(Comment comment);

    // @Delete("DELETE FROM comment WHERE id=#{id}")
    int deleteCommentById(Integer id);

   // @Update("UPDATE comment " +
   //         "SET content=#{content},created=#{created},user_id=#{userId},weibo_id=#{weiboId} " +
    //        "WHERE id=#{id}")
    int updateCommentById(Comment comment);

    //@Select("SELECT content,user_id userId " +
      //      "FROM comment " +
        //    "WHERE id=#{id}")
    CommentVO1 selectCommentById(Integer id);

    //@Select("SELECT id,content,user_id userId " +
      //      "FROM comment " +
        //    "WHERE user_id=#{id}")
    List<CommentVO2> selectCommentByUserId(Integer id);

    int dynamicUpdate(Comment comment);

    int dynamicDeleteByIds(Integer[] ids);

    int dynamicDeleteByIds2(List<Integer> ids);


}
